create database DB1

go
use DB1
CREATE TABLE Author 
(
   Id  int  NOT NULL PRIMARY KEY identity,
   FirstName  nvarchar(45) NOT NULL,
   LastName  nvarchar(45) NOT NULL,
   UpdatedTime  datetime NOT NULL
)
create view vw_Author as
select FirstName v_FirstName,LastName v_LastName from Author 
